﻿CREATE TABLE [dbo].[CLM_835_2000_ClaimPaymentProviderSummary]
(
[IDKey] [int] NOT NULL IDENTITY(1, 1),
[ClaimSubmitterID] [nvarchar] (38) NULL,
[ProviderSumm_LX01_ProviderSummaryProviderIDAssignedNumber] [nvarchar] (6) NULL,
[ProviderSumm_TS301_ProviderSummaryProviderID] [nvarchar] (30) NULL,
[ProviderSumm_TS302_ProviderSummaryFacilityTypeCode] [nvarchar] (2) NULL,
[ProviderSumm_TS303_ProviderSummaryFiscalPeriodDate] [nvarchar] (50) NULL,
[ProviderSumm_TS304_ProviderSummaryTotalClaimCount] [int] NULL,
[ProviderSumm_TS305_ProviderSummaryTotalClaimChargeAmount] [money] NULL,
[ProviderSumm_TS306_ProviderSummaryTotalCoveredChargeAmount] [money] NULL,
[ProviderSumm_TS307_ProviderSummaryTotalNoncoveredChargeAmount] [money] NULL,
[ProviderSumm_TS308_ProviderSummaryTotalDeniedChargeAmount] [money] NULL,
[ProviderSumm_TS309_ProviderSummaryTotalProviderPaymentAmount] [money] NULL,
[ProviderSumm_TS310_ProviderSummaryTotalInterestAmount] [money] NULL,
[ProviderSumm_TS311_ProviderSummaryTotalContractualAdjustmentAmount] [money] NULL,
[ProviderSumm_TS312_ProviderSummaryTotalGrammRudmanReductionAmount] [money] NULL,
[ProviderSumm_TS313_ProviderSummaryTotalMSPPayerAmount] [money] NULL,
[ProviderSumm_TS314_ProviderSummaryTotalBloodDeductibleAmount] [money] NULL,
[ProviderSumm_TS315_ProviderSummaryTotalNonLabChargeAmount] [money] NULL,
[ProviderSumm_TS316_ProviderSummaryTotalCoinsuranceAmount] [money] NULL,
[ProviderSumm_TS317_ProviderSummaryTotalHCPCSReportedChargeAmount] [money] NULL,
[ProviderSumm_TS318_ProviderSummaryTotalHCPCSPayableAmount] [money] NULL,
[ProviderSumm_TS319_ProviderSummaryTotalDeductibleAmount] [money] NULL,
[ProviderSumm_TS320_ProviderSummaryTotalProfessionalComponentAmount] [money] NULL,
[ProviderSumm_TS321_ProviderSummaryTotalMSPPatientLiabilityMetAmount] [money] NULL,
[ProviderSumm_TS322_ProviderSummaryTotalPatientReimbursementAmount] [money] NULL,
[ProviderSumm_TS323_ProviderSummaryTotalPIPClaimCount] [int] NULL,
[ProviderSumm_TS324_ProviderSummaryTotalPIPAdjustmentAmount] [money] NULL,
[ProviderSumm_TS201_ProviderSummaryTotalDRGAmount] [money] NULL,
[ProviderSumm_TS202_ProviderSummaryTotalFederalSpecificAmount] [money] NULL,
[ProviderSumm_TS203_ProviderSummaryTotalHospitalSpecificAmount] [money] NULL,
[ProviderSumm_TS204_ProviderSummaryTotalDisproportionateShareAmount] [money] NULL,
[ProviderSumm_TS205_ProviderSummaryTotalCapitalAmount] [money] NULL,
[ProviderSumm_TS206_ProviderSummaryTotalIndirectMedicalEducationAmount] [money] NULL,
[ProviderSumm_TS207_ProviderSummaryTotalOutlierDayCount] [int] NULL,
[ProviderSumm_TS208_ProviderSummaryTotalDayOutlierAmount] [money] NULL,
[ProviderSumm_TS209_ProviderSummaryTotalCostOutlierAmount] [money] NULL,
[ProviderSumm_TS210_ProviderSummaryAverageDRGLengthOfStay] [int] NULL,
[ProviderSumm_TS211_ProviderSummaryTotalDischargeCount] [int] NULL,
[ProviderSumm_TS212_ProviderSummaryTotalCostReportDayCount] [int] NULL,
[ProviderSumm_TS213_ProviderSummaryTotalCoveredDayCount] [int] NULL,
[ProviderSumm_TS214_ProviderSummaryTotalNoncoveredDayCount] [int] NULL,
[ProviderSumm_TS215_ProviderSummaryTotalMSPPassThroughAmount] [money] NULL,
[ProviderSumm_TS216_ProviderSummaryAverageDRGWeight] [int] NULL,
[ProviderSumm_TS217_ProviderSummaryTotalPPSCapitalFSPDRGAmount] [money] NULL,
[ProviderSumm_TS218_ProviderSummaryTotalPPSCapitalHSPDRGAmount] [money] NULL,
[ProviderSumm_TS219_ProviderSummaryTotalPPSDSHDRGAmount] [money] NULL,
[PatientID] [nvarchar] (80) NULL,
[SubscriberID] [nvarchar] (80) NULL,
[Corrected_NM109_CorrectedInsuredIDIndicator] [nvarchar] (80) NULL,
[ClaimDate] [nvarchar] (8) NULL,
[ServiceProvider_NM109_RenderingProviderID] [nvarchar] (80) NULL,
[TransactionSetControlNumber] [nvarchar] (9) NULL,
[Subscriber_SubscriberHierarchicalIDNumber] [int] NULL,
[BTSMessageID] [nvarchar] (100) NULL,
[BTSInterchangeID] [nvarchar] (100) NULL
) ON [PRIMARY]


